USE [IDP_SIMDB]
GO
INSERT INTO [IDP_SIMDB].[dbo].[LV_BA_CMChannelsSites]
SELECT * FROM 
OPENDATASOURCE('SQLOLEDB','DATA SOURCE=10.4.41.16\MSSQLSERVER2008;USER ID=SA;PASSWORD=lenovo,2008').
[IDP_SIMDB].[dbo].[LV_BA_CMChannelsSites]
GO
INSERT INTO [IDP_SIMDB].[dbo].[LV_BA_CMDealer]
SELECT * FROM 
OPENDATASOURCE('SQLOLEDB','DATA SOURCE=10.4.41.16\MSSQLSERVER2008;USER ID=SA;PASSWORD=lenovo,2008').
[IDP_SIMDB].[dbo].[LV_BA_CMDealer]
GO
INSERT INTO [IDP_SIMDB].[dbo].[LV_BA_CMEngineer]
SELECT * FROM 
OPENDATASOURCE('SQLOLEDB','DATA SOURCE=10.4.41.16\MSSQLSERVER2008;USER ID=SA;PASSWORD=lenovo,2008').
[IDP_SIMDB].[dbo].[LV_BA_CMEngineer]
GO
INSERT INTO [IDP_SIMDB].[dbo].[LV_BA_NPIColor_Trl]
SELECT * FROM 
OPENDATASOURCE('SQLOLEDB','DATA SOURCE=10.4.41.16\MSSQLSERVER2008;USER ID=SA;PASSWORD=lenovo,2008').
[IDP_SIMDB].[dbo].[LV_BA_NPIColor_Trl]
GO
INSERT INTO [IDP_SIMDB].[dbo].[LV_BA_NPIFaultCode]
SELECT * FROM 
OPENDATASOURCE('SQLOLEDB','DATA SOURCE=10.4.41.16\MSSQLSERVER2008;USER ID=SA;PASSWORD=lenovo,2008').
[IDP_SIMDB].[dbo].[LV_BA_NPIFaultCode]
GO
INSERT INTO [IDP_SIMDB].[dbo].[LV_BA_NPIKeyAccount]
SELECT * FROM 
OPENDATASOURCE('SQLOLEDB','DATA SOURCE=10.4.41.16\MSSQLSERVER2008;USER ID=SA;PASSWORD=lenovo,2008').
[IDP_SIMDB].[dbo].[LV_BA_NPIKeyAccount]
GO
INSERT INTO [IDP_SIMDB].[dbo].[LV_BA_NPIPhoneModel_Trl]
SELECT * FROM 
OPENDATASOURCE('SQLOLEDB','DATA SOURCE=10.4.41.16\MSSQLSERVER2008;USER ID=SA;PASSWORD=lenovo,2008').
[IDP_SIMDB].[dbo].[LV_BA_NPIPhoneModel_Trl]
GO
INSERT INTO [IDP_SIMDB].[dbo].[LV_BA_NPIProductLine_Trl]
SELECT * FROM 
OPENDATASOURCE('SQLOLEDB','DATA SOURCE=10.4.41.16\MSSQLSERVER2008;USER ID=SA;PASSWORD=lenovo,2008').
[IDP_SIMDB].[dbo].[LV_BA_NPIProductLine_Trl]
GO
INSERT INTO [IDP_SIMDB].[dbo].[LV_BA_NPIRepairWay_trl]
SELECT * FROM 
OPENDATASOURCE('SQLOLEDB','DATA SOURCE=10.4.41.16\MSSQLSERVER2008;USER ID=SA;PASSWORD=lenovo,2008').
[IDP_SIMDB].[dbo].[LV_BA_NPIRepairWay_trl]
GO
INSERT INTO [IDP_SIMDB].[dbo].[LV_BA_PMPart]
SELECT * FROM 
OPENDATASOURCE('SQLOLEDB','DATA SOURCE=10.4.41.16\MSSQLSERVER2008;USER ID=SA;PASSWORD=lenovo,2008').
[IDP_SIMDB].[dbo].[LV_BA_PMPart]
GO